set more off
capture log close
cd "location"

capture log close
log using "Tables in Appendix.log",replace

use "QATARAID_PANEL_ESTIMATIONS.dta", clear
tab year

**Table A2. Correlation matrix (2014-2021)**
corr political_interests qatarblockade polity2 v2x_polyarchy mediation_new muslimmajority arableague ln_qatarimports_un_v2 ln_qatarexports_un_v2 ln_qatartrade  ln_gdp_per_capita_WB gdppc_growth lninfant ln_pop qatardistance dumcovid


**Table A3. Heckman-Poisson estimation results with exports (2014-2021)
**Model 1
heckpoisson aidinteractions L.political_interests L.mediation_new muslimmajority arableague L.ln_qatarexports_un_v2   L.ln_gdp_per_capita_WB  dumcovid, select (aidstatus= L.aidstatus L.political_interests L.mediation_new muslimmajority arableague L.ln_qatarexports_un_v2  L.ln_gdp_per_capita_WB   dumcovid)
outreg2 using TableA3.xls, bdec(4) pvalue tdec(4) asterisk(coef) drop(year*)   replace

**Model 2
heckpoisson aidinteractions L.political_interests L.mediation_new muslimmajority arableague L.ln_qatarexports_un_v2  L.lninfant  dumcovid , select (aidstatus= L.aidstatus L.political_interests L.mediation_new muslimmajority arableague L.ln_qatarexports_un_v2  L.lninfant  dumcovid )
outreg2 using TableA3.xls, bdec(4) pvalue tdec(4) asterisk(coef) drop(year*)  append 

**Model 3
heckpoisson aidinteractions L.political_interests L.mediation_new qatarblockade muslimmajority arableague L.ln_qatarexports_un_v2   L.ln_gdp_per_capita_WB  dumcovid, select (aidstatus= L.aidstatus L.political_interests L.mediation_new qatarblockade muslimmajority arableague L.ln_qatarexports_un_v2  L.ln_gdp_per_capita_WB  dumcovid)
outreg2 using TableA3.xls, bdec(4) pvalue tdec(4) asterisk(coef) drop(year*)  append 


**Model 4
heckpoisson aidinteractions L.political_interests L.mediation_new qatarblockade muslimmajority arableague L.ln_qatarexports_un_v2  L.lninfant  dumcovid, select (aidstatus= L.aidstatus L.political_interests L.mediation_new qatarblockade muslimmajority arableague L.ln_qatarexports_un_v2  L.lninfant  dumcovid)
outreg2 using TableA3.xls, bdec(4) pvalue tdec(4) asterisk(coef) drop(year*)  append 

**
**Table A4. Heckman-Poisson estimation results with Year Dummy

tab year
**Model 1
heckpoisson aidinteractions L.political_interests L.mediation_new muslimmajority arableague L.ln_qatarimports_un_v2   L.ln_gdp_per_capita_WB L.ln_pop dumyear, select (aidstatus= L.aidstatus L.political_interests L.mediation_new muslimmajority arableague L.ln_qatarimports_un_v2  L.ln_gdp_per_capita_WB L.ln_pop  dumyear)
outreg2 using TableA4.xls, bdec(4) pvalue tdec(4) asterisk(coef) drop(year*)   replace

**Model 2
heckpoisson aidinteractions L.political_interests L.mediation_new muslimmajority arableague L.ln_qatarimports_un_v2  L.lninfant L.ln_pop dumyear , select (aidstatus= L.aidstatus L.political_interests L.mediation_new muslimmajority arableague L.ln_qatarimports_un_v2  L.lninfant L.ln_pop dumyear )
outreg2 using TableA4.xls, bdec(4) pvalue tdec(4) asterisk(coef) drop(year*)  append 

**Model 3
heckpoisson aidinteractions L.political_interests L.mediation_new qatarblockade muslimmajority arableague L.ln_qatarimports_un_v2   L.ln_gdp_per_capita_WB L.ln_pop dumyear, select (aidstatus= L.aidstatus L.political_interests L.mediation_new qatarblockade muslimmajority arableague L.ln_qatarimports_un_v2  L.ln_gdp_per_capita_WB L.ln_pop dumyear)
outreg2 using TableA4.xls, bdec(4) pvalue tdec(4) asterisk(coef) drop(year*)  append 


**Model 4
heckpoisson aidinteractions L.political_interests L.mediation_new qatarblockade muslimmajority arableague L.ln_qatarimports_un_v2  L.lninfant L.ln_pop dumyear, select (aidstatus= L.aidstatus L.political_interests L.mediation_new qatarblockade muslimmajority arableague L.ln_qatarimports_un_v2  L.lninfant L.ln_pop dumyear)
outreg2 using TableA4.xls, bdec(4) pvalue tdec(4) asterisk(coef) drop(year*)  append 

****

**Table A5. Heckman-Poisson estimation results with Additional Controls
**Model 1
heckpoisson aidinteractions L.political_interests L.mediation_new muslimmajority arableague L.ln_qatarimports_un_v2   L.ln_gdp_per_capita_WB L.ln_pop dumcovid v2x_polyarchy  gdppc_growth  qatardistance , select (aidstatus= L.aidstatus L.political_interests L.mediation_new muslimmajority arableague L.ln_qatarimports_un_v2  L.ln_gdp_per_capita_WB L.ln_pop  dumcovid v2x_polyarchy  gdppc_growth  qatardistance  )
outreg2 using  Table5.xls, bdec(4) pvalue tdec(4) asterisk(coef) drop(year*)   replace

**Model 2
heckpoisson aidinteractions L.political_interests L.mediation_new muslimmajority arableague L.ln_qatarimports_un_v2  L.lninfant L.ln_pop dumcovid v2x_polyarchy  gdppc_growth  qatardistance  , select (aidstatus= L.aidstatus L.political_interests L.mediation_new muslimmajority arableague L.ln_qatarimports_un_v2  L.lninfant L.ln_pop dumcovid v2x_polyarchy  gdppc_growth  qatardistance  )
outreg2 using  Table5.xls, bdec(4) pvalue tdec(4) asterisk(coef) drop(year*)  append 

**Model 3
heckpoisson aidinteractions L.political_interests L.mediation_new qatarblockade muslimmajority arableague L.ln_qatarimports_un_v2   L.ln_gdp_per_capita_WB L.ln_pop dumcovid v2x_polyarchy  gdppc_growth  qatardistance , select (aidstatus= L.aidstatus L.political_interests L.mediation_new qatarblockade muslimmajority arableague L.ln_qatarimports_un_v2  L.ln_gdp_per_capita_WB L.ln_pop dumcovid v2x_polyarchy  gdppc_growth  qatardistance )
outreg2 using  Table5.xls, bdec(4) pvalue tdec(4) asterisk(coef) drop(year*)  append 


**Model 4
heckpoisson aidinteractions L.political_interests L.mediation_new qatarblockade muslimmajority arableague L.ln_qatarimports_un_v2  L.lninfant L.ln_pop dumcovid v2x_polyarchy  gdppc_growth  qatardistance , select (aidstatus= L.aidstatus L.political_interests L.mediation_new qatarblockade muslimmajority arableague L.ln_qatarimports_un_v2  L.lninfant L.ln_pop dumcovid v2x_polyarchy  gdppc_growth  qatardistance )
outreg2 using  Table5.xls, bdec(4) pvalue tdec(4) asterisk(coef) drop(year*)  append 



log close

